// ******************************************************************
// * Copyright(c)  Steven Lu
// * Description   : Schema_PROD_PLAN_ORDER
// * CreateDate    : 2012/7/20 23:13:18
// * Creater       : CodeSmith
// * LastChangeDate: 2012/7/20 23:13:18
// * LastChanger   : 2012/7/20 23:13:18
// * Version Info  : 1.0 For ESOL
// ******************************************************************

using System;
using System.Collections.Generic;
using System.Text;
using Suzsoft.Smart.EntityCore;

namespace ESOL.Common.Schema
{
    [Serializable]
    public partial class ProdPlanOrderTable : TableInfo
    {
        public const string C_TableName = "PROD_PLAN_ORDER";

        public const string C_PLAN_ORDER_ID = "PLAN_ORDER_ID";
        public const string C_PLAN_ORDER_CODE = "PLAN_ORDER_CODE";
        public const string C_APPLICATION_ITEM_ID = "APPLICATION_ITEM_ID";
        public const string C_BLUEPRINT_ID = "BLUEPRINT_ID";
        public const string C_BOM_ID = "BOM_ID";
        public const string C_QTY = "QTY";
        public const string C_DELIVERY_DATE = "DELIVERY_DATE";
        public const string C_PRODUCT_STATUS = "PRODUCT_STATUS";
        public const string C_LOCATION_CODE = "LOCATION_CODE";
        public const string C_PLAN_ORDER_PERSN = "PLAN_ORDER_PERSN";
        public const string C_PLAN_ORDER_DATE = "PLAN_ORDER_DATE";
        public const string C_CREATED_DATE = "CREATED_DATE";
        public const string C_CREATED_BY = "CREATED_BY";
        public const string C_LAST_MODIFIED_DATE = "LAST_MODIFIED_DATE";
        public const string C_LAST_MODIFIED_BY = "LAST_MODIFIED_BY";
        public const string C_STATUS = "STATUS";
        public const string C_ASSEMBLE_REPORT_QTY = "ASSEMBLE_REPORT_QTY";
        public const string C_REMARK = "REMARK";
        public const string C_IS_MARK = "IS_MARK";
        public const string C_ORDER_STATUS = "ORDER_STATUS";
        public const string C_CHANGED_ORDER_ID = "CHANGED_ORDER_ID";

        public ProdPlanOrderTable()
        {
            _tableName = "PROD_PLAN_ORDER";
        }

        protected static ProdPlanOrderTable _current;
        public static ProdPlanOrderTable Current
        {
            get
            {
                if (_current == null)
                {
                    Initial();
                }
                return _current;
            }
        }

        private static void Initial()
        {
            _current = new ProdPlanOrderTable();

            _current.Add(C_PLAN_ORDER_ID, new ColumnInfo(C_PLAN_ORDER_ID, "PlanOrderId", true, typeof(string)));
            _current.Add(C_PLAN_ORDER_CODE, new ColumnInfo(C_PLAN_ORDER_CODE, "PlanOrderCode", false, typeof(string)));
            _current.Add(C_APPLICATION_ITEM_ID, new ColumnInfo(C_APPLICATION_ITEM_ID, "ApplicationItemId", false, typeof(string)));
            _current.Add(C_BLUEPRINT_ID, new ColumnInfo(C_BLUEPRINT_ID, "BlueprintId", false, typeof(string)));
            _current.Add(C_BOM_ID, new ColumnInfo(C_BOM_ID, "BomId", false, typeof(string)));
            _current.Add(C_QTY, new ColumnInfo(C_QTY, "Qty", false, typeof(decimal)));
            _current.Add(C_DELIVERY_DATE, new ColumnInfo(C_DELIVERY_DATE, "DeliveryDate", false, typeof(DateTime)));
            _current.Add(C_PRODUCT_STATUS, new ColumnInfo(C_PRODUCT_STATUS, "ProductStatus", false, typeof(string)));
            _current.Add(C_LOCATION_CODE, new ColumnInfo(C_LOCATION_CODE, "LocationCode", false, typeof(string)));
            _current.Add(C_PLAN_ORDER_PERSN, new ColumnInfo(C_PLAN_ORDER_PERSN, "PlanOrderPersn", false, typeof(string)));
            _current.Add(C_PLAN_ORDER_DATE, new ColumnInfo(C_PLAN_ORDER_DATE, "PlanOrderDate", false, typeof(DateTime)));
            _current.Add(C_CREATED_DATE, new ColumnInfo(C_CREATED_DATE, "CreatedDate", false, typeof(DateTime)));
            _current.Add(C_CREATED_BY, new ColumnInfo(C_CREATED_BY, "CreatedBy", false, typeof(string)));
            _current.Add(C_LAST_MODIFIED_DATE, new ColumnInfo(C_LAST_MODIFIED_DATE, "LastModifiedDate", false, typeof(DateTime)));
            _current.Add(C_LAST_MODIFIED_BY, new ColumnInfo(C_LAST_MODIFIED_BY, "LastModifiedBy", false, typeof(string)));
            _current.Add(C_STATUS, new ColumnInfo(C_STATUS, "Status", false, typeof(string)));
            _current.Add(C_ASSEMBLE_REPORT_QTY, new ColumnInfo(C_ASSEMBLE_REPORT_QTY, "AssembleReportQty", false, typeof(decimal)));
            _current.Add(C_REMARK, new ColumnInfo(C_REMARK, "Remark", false, typeof(string)));
            _current.Add(C_IS_MARK, new ColumnInfo(C_IS_MARK, "IsMark", false, typeof(int)));
            _current.Add(C_ORDER_STATUS, new ColumnInfo(C_ORDER_STATUS, "OrderStatus", false, typeof(int)));
            _current.Add(C_CHANGED_ORDER_ID, new ColumnInfo(C_CHANGED_ORDER_ID, "ChangedOrderId", false, typeof(string)));

        }

        public ColumnInfo PLAN_ORDER_ID
        {
            get { return this[C_PLAN_ORDER_ID]; }
        }

        public ColumnInfo PLAN_ORDER_CODE
        {
            get { return this[C_PLAN_ORDER_CODE]; }
        }

        public ColumnInfo APPLICATION_ITEM_ID
        {
            get { return this[C_APPLICATION_ITEM_ID]; }
        }

        public ColumnInfo BLUEPRINT_ID
        {
            get { return this[C_BLUEPRINT_ID]; }
        }

        public ColumnInfo BOM_ID
        {
            get { return this[C_BOM_ID]; }
        }

        public ColumnInfo QTY
        {
            get { return this[C_QTY]; }
        }

        public ColumnInfo DELIVERY_DATE
        {
            get { return this[C_DELIVERY_DATE]; }
        }

        public ColumnInfo PRODUCT_STATUS
        {
            get { return this[C_PRODUCT_STATUS]; }
        }

        public ColumnInfo LOCATION_CODE
        {
            get { return this[C_LOCATION_CODE]; }
        }

        public ColumnInfo PLAN_ORDER_PERSN
        {
            get { return this[C_PLAN_ORDER_PERSN]; }
        }

        public ColumnInfo PLAN_ORDER_DATE
        {
            get { return this[C_PLAN_ORDER_DATE]; }
        }

        public ColumnInfo CREATED_DATE
        {
            get { return this[C_CREATED_DATE]; }
        }

        public ColumnInfo CREATED_BY
        {
            get { return this[C_CREATED_BY]; }
        }

        public ColumnInfo LAST_MODIFIED_DATE
        {
            get { return this[C_LAST_MODIFIED_DATE]; }
        }

        public ColumnInfo LAST_MODIFIED_BY
        {
            get { return this[C_LAST_MODIFIED_BY]; }
        }

        public ColumnInfo STATUS
        {
            get { return this[C_STATUS]; }
        }

        public ColumnInfo ASSEMBLE_REPORT_QTY
        {
            get { return this[C_ASSEMBLE_REPORT_QTY]; }
        }

        public ColumnInfo REMARK
        {
            get { return this[C_REMARK]; }
        }

        public ColumnInfo IS_MARK
        {
            get { return this[C_IS_MARK]; }
        }

        public ColumnInfo ORDER_STATUS
        {
            get { return this[C_ORDER_STATUS]; }
        }

        public ColumnInfo CHANGED_ORDER_ID
        {
            get { return this[C_CHANGED_ORDER_ID]; }
        }



    }
}

